Columns
Grants
Dependencies
Details
Triggers
Errors
Columns
Grants
Dependencies
Details
Triggers
Errors
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS | INSERTABLE | UPDATABLE | DELETABLE |
---|---|---|---|---|---|---|---|---|
OBJ | VARCHAR2(20) | No | null | 1 | null | NO | NO | NO |
SH_OBJ | VARCHAR2(20) | No | null | 2 | null | NO | NO | NO |
SH_DISPLAY | VARCHAR2(400) | Yes | null | 3 | null | NO | NO | NO |
START_DATE | DATE | No | null | 4 | null | NO | NO | NO |
END_DATE | DATE | Yes | null | 5 | null | NO | NO | NO |
SH_ROLE | NUMBER(38) | No | null | 6 | null | NO | NO | NO |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_ALL_FILES_INTAKE_ASSOC | VIEW | QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW |
QART | V_ALL_INACTIVE_ACTIVITIES | VIEW | QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW |
QART | V_BEHAVE_SCI_FILES | VIEW | QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW |
QART | V_F_ANP | VIEW | QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW |
QART | V_SIII_INV_ACTS | VIEW | QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW |
QART | MV_SIIA_ANALYSIS | MATERIALIZED VIEW | QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW |
References
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_STAKEHOLDER_ROLE | TABLE |
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_STAKEHOLDER | TABLE |
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_STAKEHOLDER_ROLE | TABLE |
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_STAKEHOLDER | TABLE |
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_STAKEHOLDER_ROLE | TABLE |
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_STAKEHOLDER | TABLE |
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_STAKEHOLDER_ROLE | TABLE |
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_STAKEHOLDER | TABLE |
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_STAKEHOLDER_ROLE | TABLE |
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_STAKEHOLDER | TABLE |
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_STAKEHOLDER_ROLE | TABLE |
QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW | QART | MV_ACM_STAKEHOLDER | TABLE |
NAME | VALUE |
---|---|
CREATED | 12-APR-23 |
LAST_DDL_TIME | 12-APR-23 |
OWNER | QART |
VIEW_NAME | V_CURR_OBJ_SUPPORT_OFFICER |
TEXT_LENGTH | 553 |
TEXT | SELECT S.OBJ, S.STAKEHOLDER SH_OBJ, SH.TAGLINE SH_DISPLAY, S.START_DATE, S.END_DATE, S.SH_ROLE FROM MV_ACM_STAKEHOLDER S INNER JOIN MV_ACM_OBJ SH ON SH.SID = S.STAKEHOLDER WHERE ( S.START_DATE IS NULL OR S.START_DATE <= SYSTIMESTAMP ) AND ( S.END_DATE IS NULL OR S.END_DATE >= SYSTIMESTAMP ) AND S.SH_ROLE IN ( SELECT SID FROM MV_ACM_STAKEHOLDER_ROLE WHERE CODE = 'SUPPORT' ) |
TEXT_VC | SELECT S.OBJ, S.STAKEHOLDER SH_OBJ, SH.TAGLINE SH_DISPLAY, S.START_DATE, S.END_DATE, S.SH_ROLE FROM MV_ACM_STAKEHOLDER S INNER JOIN MV_ACM_OBJ SH ON SH.SID = S.STAKEHOLDER WHERE ( S.START_DATE IS NULL OR S.START_DATE <= SYSTIMESTAMP ) AND ( S.END_DATE IS NULL OR S.END_DATE >= SYSTIMESTAMP ) AND S.SH_ROLE IN ( SELECT SID FROM MV_ACM_STAKEHOLDER_ROLE WHERE CODE = 'SUPPORT' ) |
TYPE_TEXT_LENGTH | null |
TYPE_TEXT | null |
OID_TEXT_LENGTH | null |
OID_TEXT | null |
VIEW_TYPE_OWNER | null |
VIEW_TYPE | null |
SUPERVIEW_NAME | null |
EDITIONING_VIEW | N |
READ_ONLY | N |
CONTAINER_DATA | N |
BEQUEATH | DEFINER |
ORIGIN_CON_ID | 16 |
DEFAULT_COLLATION | USING_NLS_COMP |
CONTAINERS_DEFAULT | NO |
CONTAINER_MAP | NO |
EXTENDED_DATA_LINK | NO |
EXTENDED_DATA_LINK_MAP | NO |
HAS_SENSITIVE_COLUMN | NO |
ADMIT_NULL | NO |
PDB_LOCAL_ONLY | NO |
DUPLICATED | N |
SHARDED | N |
OWNER | TRIGGER_NAME | TRIGGER_TYPE | TRIGGERING_EVENT | STATUS | OBJECT_ID |
---|
ATTRIBUTE | Line:Position | TEXT |
---|